Skip to main content

SUM

1. Description​

The SUM Derivation Type is used to compute the sum of a field after data has been grouped based on the specified group-by keys.

2. Screen Configuration​

sum_image

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type.
  • derivation
    • derivation_type: The derivation type used is "SUM".
    • req_fields
      • Expression: An expression containing fields from the input metadata must be provided.
      • Apply Exchange: Possible values are "True" and "False".
      • Operation: Possible values are "ACC_ABS", "ACC_NEG", "GROUP_ABS", "GROUP_NEG" and "NONE".

3.1 Expression​

  • The expression is evaluated for each record, and the SUM operation is then applied to the computed values.

3.2 Apply Exchange​

3.3 Operation​

  • This parameter determines whether absolute or negative transformations are applied at the account level or group level.